<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  
  
  <title>MySQL安装 | Hexo</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta name="description" content="MySQL安装（5.7.19为例）1、下载地址：https:&#x2F;&#x2F;downloads.mysql.com&#x2F;archives&#x2F;installer&#x2F; 2、开始安装：1.在Product Version中选择自己想要下载的版本  2.选择5.7.19的版本  3.选择mysql-installer-community-5.7.19.0.msi，点击Download下载  4.双击运行下载好的mysql-i">
<meta property="og:type" content="article">
<meta property="og:title" content="MySQL安装">
<meta property="og:url" content="http://example.com/2021/11/02/MySQL%E5%AE%89%E8%A3%85/index.html">
<meta property="og:site_name" content="Hexo">
<meta property="og:description" content="MySQL安装（5.7.19为例）1、下载地址：https:&#x2F;&#x2F;downloads.mysql.com&#x2F;archives&#x2F;installer&#x2F; 2、开始安装：1.在Product Version中选择自己想要下载的版本  2.选择5.7.19的版本  3.选择mysql-installer-community-5.7.19.0.msi，点击Download下载  4.双击运行下载好的mysql-i">
<meta property="og:locale" content="en_US">
<meta property="og:image" content="https://pic7.58cdn.com.cn/nowater/webim/big/n_v29654ced4aee54c99bfd9a76b5ddc91f1.png">
<meta property="og:image" content="https://pic2.58cdn.com.cn/nowater/webim/big/n_v210353f21a2b14ee5a1630e914b4fea30.png">
<meta property="og:image" content="https://pic3.58cdn.com.cn/nowater/webim/big/n_v2ee9d66afcf284ed591a3b0001f444c38.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831314-6138-20170722230026215-1797155710.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831314-1312-20170722230046043-978659071.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831314-6490-20170722230201246-220989429.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831314-6339-20170722230232793-1759462371.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831314-7923-20170722230314340-1501335191.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831315-4997-1-20170722230439528-92431868.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831315-6544-20170722230506262-176699446.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831315-4350-20170722230524700-2060141633.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831315-5686-20170722230808200-494027333.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831316-1727-20170722230838934-1132653366.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831316-4284-20170722230918575-127114164.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831316-1042-20170722231058356-1269244144.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831317-1713-20170722231209903-956653442.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831317-3908-20170722231228387-1590560639.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831317-1586-20170722231608825-2099636815.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831317-4097-20170722231638887-180558399.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831318-8984-20170722231654278-649027984.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831318-9740-20170722231714809-1553936235.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831318-2164-20170722231738825-1692782858.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831318-2952-20170722231755762-1299837152.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831319-7917-20170722231811528-357673493.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831319-7786-20170722231826746-634086390.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831319-2072-20170722231844528-1242732523.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831319-9386-20170722231902950-256599456.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831319-1406-20170722231933637-179722774.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831320-7960-20170722232012418-1876643408.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831320-7374-41-20170722232031684-1843508.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831320-5015-20170722232044090-1304683536.png">
<meta property="og:image" content="https://www.runoob.com/wp-content/uploads/2019/10/1571831320-6727-20170722232055731-2127042770.png">
<meta property="article:published_time" content="2021-11-01T16:11:02.000Z">
<meta property="article:modified_time" content="2021-11-02T14:42:35.404Z">
<meta property="article:author" content="John Doe">
<meta property="article:tag" content="MySQL安装">
<meta name="twitter:card" content="summary">
<meta name="twitter:image" content="https://pic7.58cdn.com.cn/nowater/webim/big/n_v29654ced4aee54c99bfd9a76b5ddc91f1.png">
  
    <link rel="alternate" href="/atom.xml" title="Hexo" type="application/atom+xml">
  
  
    <link rel="shortcut icon" href="/favicon.png">
  
  
    
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/typeface-source-code-pro@0.0.71/index.min.css">

  
  
<link rel="stylesheet" href="/css/style.css">

  
    
<link rel="stylesheet" href="/fancybox/jquery.fancybox.min.css">

  
<meta name="generator" content="Hexo 5.4.0"></head>

<body>
  <div id="container">
    <div id="wrap">
      <header id="header">
  <div id="banner"></div>
  <div id="header-outer" class="outer">
    <div id="header-title" class="inner">
      <h1 id="logo-wrap">
        <a href="/" id="logo">Hexo</a>
      </h1>
      
    </div>
    <div id="header-inner" class="inner">
      <nav id="main-nav">
        <a id="main-nav-toggle" class="nav-icon"></a>
        
          <a class="main-nav-link" href="/">Home</a>
        
          <a class="main-nav-link" href="/archives">Archives</a>
        
      </nav>
      <nav id="sub-nav">
        
          <a id="nav-rss-link" class="nav-icon" href="/atom.xml" title="RSS Feed"></a>
        
        <a id="nav-search-btn" class="nav-icon" title="Search"></a>
      </nav>
      <div id="search-form-wrap">
        <form action="//google.com/search" method="get" accept-charset="UTF-8" class="search-form"><input type="search" name="q" class="search-form-input" placeholder="Search"><button type="submit" class="search-form-submit">&#xF002;</button><input type="hidden" name="sitesearch" value="http://example.com"></form>
      </div>
    </div>
  </div>
</header>

      <div class="outer">
        <section id="main"><article id="post-MySQL安装" class="h-entry article article-type-post" itemprop="blogPost" itemscope itemtype="https://schema.org/BlogPosting">
  <div class="article-meta">
    <a href="/2021/11/02/MySQL%E5%AE%89%E8%A3%85/" class="article-date">
  <time class="dt-published" datetime="2021-11-01T16:11:02.000Z" itemprop="datePublished">2021-11-02</time>
</a>
    
  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 class="p-name article-title" itemprop="headline name">
      MySQL安装
    </h1>
  

      </header>
    
    <div class="e-content article-entry" itemprop="articleBody">
      
        <h1 id="MySQL安装（5-7-19为例）"><a href="#MySQL安装（5-7-19为例）" class="headerlink" title="MySQL安装（5.7.19为例）"></a>MySQL安装（5.7.19为例）</h1><h2 id="1、下载地址："><a href="#1、下载地址：" class="headerlink" title="1、下载地址："></a>1、下载地址：</h2><p><a target="_blank" rel="noopener" href="https://downloads.mysql.com/archives/installer/">https://downloads.mysql.com/archives/installer/</a></p>
<h2 id="2、开始安装："><a href="#2、开始安装：" class="headerlink" title="2、开始安装："></a>2、开始安装：</h2><p><strong>1.在Product Version中选择自己想要下载的版本</strong></p>
<p><img src="https://pic7.58cdn.com.cn/nowater/webim/big/n_v29654ced4aee54c99bfd9a76b5ddc91f1.png"></p>
<p><strong>2.选择5.7.19的版本</strong></p>
<p><img src="https://pic2.58cdn.com.cn/nowater/webim/big/n_v210353f21a2b14ee5a1630e914b4fea30.png"></p>
<p><strong>3.选择mysql-installer-community-5.7.19.0.msi，点击Download下载</strong></p>
<p><img src="https://pic3.58cdn.com.cn/nowater/webim/big/n_v2ee9d66afcf284ed591a3b0001f444c38.png"></p>
<p><strong>4.双击运行下载好的mysql-installer-community-5.7.19.0.msi，程序运行需要一些时间准备，请等待一下。</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831314-6138-20170722230026215-1797155710.png" alt="img"></p>
<p><strong>5.运行成功之后，进入欢迎的界面，选择我同意协议</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831314-1312-20170722230046043-978659071.png" alt="img"></p>
<p><strong>6.进入类型选择页面，本人需要mysql云服务就选择了developer default（6.1是默认安装的步骤），如果只想安装mysql server的就选择custom模式（6.2步骤是选择自己需要的服务器类型，所选择的用于做一些数据分析）</strong></p>
<ul>
<li>developer default（开发者默认）：安装mysql开发所需的所有产品</li>
<li>server only（服务器）：只安装mysql服务器产品</li>
<li>client only（客户端）：只安装没有服务器的mysql客户端产品</li>
<li>full（完全）：安装所有包含的mysql产品和功能</li>
<li>custom（手动）：手动选择系统上应安装的产品</li>
</ul>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831314-6490-20170722230201246-220989429.png" alt="img"></p>
<p><strong>6.1开发者默认模式检测以下程序会安装不成功，点击下一步进入下一个安装流程—&gt;跳到第7步。</strong></p>
<p>check requirements：以下产品的请求失败，安装程序将自动尝试解决其中一些问题。标记为手动的要求无法自动解决。单击这些项目以尝试手动恢复。</p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831314-6339-20170722230232793-1759462371.png" alt="img"></p>
<p><strong>检测到不可安装的程序说明：</strong></p>
<p>Visual Studio：是一款代码编辑工具（可编写C#、Visual Basic、C++、TypeScript、F# ），如果你安装的话就安装要求去安装Visual Studio version：2012.2013.2015.2017其中一个版本</p>
<p>Connector/pyton 3.4：电脑有python3.6了就没选择3.4版本的。如果你没安装有python可按要求去安装一些内容。</p>
<p><strong>6.2选择mysql server（服务） 5.7.36 x64 ；选择mysql workbench(mysql 的工作薄) 6.3.9 x64</strong></p>
<p>选择mysql notiyier(通知) 1.1.7 x86(因为这里只有一个选择所以选择了86)点击下一步进入下一个安装流程—&gt;跳到第8步。</p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831314-7923-20170722230314340-1501335191.png" alt="img"></p>
<p><strong>7.当我们点击下一步的时候安装程序出现了提示：（一个或者移动产品要求没有得到满足，那些符合要求的产品将不会安装/升级。你想要继续吗），这里我选择的是：YES</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831315-4997-1-20170722230439528-92431868.png" alt="img"></p>
<p><strong>8.在安装所选界面能看到我们接下来所需要安装的程序，点击execute</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831315-6544-20170722230506262-176699446.png" alt="img"></p>
<p><strong>9.安装程序进度界面，安装需要一些时间。点击dide tails能看到安装日志</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831315-4350-20170722230524700-2060141633.png" alt="img"></p>
<p><strong>10.程序安装完成之后，点击next</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831315-5686-20170722230808200-494027333.png" alt="img"></p>
<p><strong>11.在product configutration（产品配置）页面能看到需要配置的程序，点击next（页面英语介绍：现在我们将逐一介绍以下产品的配置向导。您可以随时取消，如果您希望离开此向导，而不必配置所有产品）</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831316-1727-20170722230838934-1132653366.png" alt="img"></p>
<p><strong>12.先配置mysql server的类型以及网络：type and networking（类型和网络），这里有两种mysql server类型，选择第一种类型点击next。</strong></p>
<p>有两种类型简单介绍</p>
<ul>
<li><p>1.standalone mysql server/classic mysql replication：独立的mysql服务器/经典的mysql复制。</p>
<p>choose this option if you want to run the mysql server either standalone with the opportunity to later configure classic mysql replication：选择这个选项，如果你想运行mysql服务器是独立的，有机会以后配置经典的mysql复制</p>
</li>
<li><p>\2. innodb cluster sandbox thst setup(for testing only)：</p>
</li>
</ul>
<p><strong>innodb集群沙箱thst设置（仅用于测试）</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831316-4284-20170722230918575-127114164.png" alt="img"></p>
<p><strong>13.设置服务器配置类型以及连接端口：继续next</strong></p>
<p><strong>Config Type：</strong>选择Development Machine，用于小型以及学习所用足够了。</p>
<p><strong>Port number：</strong>输入3306，也可以输入其他最好是3306-3309之间。</p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831316-1042-20170722231058356-1269244144.png" alt="img"></p>
<p><strong>14.配置root的密码（该密码要记住），系统提示这密码虚弱</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831317-1713-20170722231209903-956653442.png" alt="img"></p>
<p><strong>15.添加其他管理员，点击add user 输入账号密码点击ok（如果添加的管理员只允许在本地登录就将host改成local），回到界面之后点击next</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831317-3908-20170722231228387-1590560639.png" alt="img"></p>
<p><strong>16.配置mysql在windows系统中的名字，是否选择开机启动mysql服务，其它的没进行修改，点击”Next”。</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831317-1586-20170722231608825-2099636815.png" alt="img"></p>
<p><strong>17.配置插件和扩展页面没进行修改直接下一步：</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831317-4097-20170722231638887-180558399.png" alt="img"></p>
<p><strong>18.Mysql server :apply configuration（应用配置页面），选择execute进行安装配置</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831318-8984-20170722231654278-649027984.png" alt="img"></p>
<p><strong>19. mysql server应用配置的log，选择finish</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831318-9740-20170722231714809-1553936235.png" alt="img"></p>
<p><strong>20.安装程序又回到了product configutration（产品配置）页面，此时我们看到mysql server安装成功的显示，继续下一步：</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831318-2164-20170722231738825-1692782858.png" alt="img"></p>
<p><strong>21.配置mysql router：勾选configure mysql route for innoDB cluster之后输入密码。（如果不想输入密码可直接点击点一下）点击下一步</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831318-2952-20170722231755762-1299837152.png" alt="img"></p>
<p><strong>22.Mysql router :apply configuration（应用配置页面）点击execute</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831319-7917-20170722231811528-357673493.png" alt="img"></p>
<p><strong>23.安装完成之后点击选择finish</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831319-7786-20170722231826746-634086390.png" alt="img"></p>
<p><strong>24.检测root密码</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831319-2072-20170722231844528-1242732523.png" alt="img"></p>
<p><strong>25.安装一些server，老规矩点击execute，完成之后点击finish</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831319-9386-20170722231902950-256599456.png" alt="img"></p>
<p><strong>26.程序回到产品配置页面。继续下一步：</strong></p>
<p><strong>27.安装程序完成界面。</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831319-1406-20170722231933637-179722774.png" alt="img"></p>
<p><strong>28.双击运行之前下载的安装包，能看到我们所安装的产品。</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831320-7960-20170722232012418-1876643408.png" alt="img"></p>
<h1 id="配置mysql环境变量"><a href="#配置mysql环境变量" class="headerlink" title="配置mysql环境变量"></a>配置mysql环境变量</h1><p><strong>1.上面安装的是时候我们看到mysql默认安装路径是：C:\Program Files\MySQL\MySQL Server 5.7我的电脑右键—&gt;属性à高级系统设置à环境变量à新建MYSQL_HOME,将安装目录输入：</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831320-7374-41-20170722232031684-1843508.png" alt="img"></p>
<p><strong>找到path编辑：输入%MYSQL_HOME%\bin</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831320-5015-20170722232044090-1304683536.png" alt="img"></p>
<p><strong>打开cmd输入mysql –u root –p</strong></p>
<p><strong>输入root密码</strong></p>
<p><img src="https://www.runoob.com/wp-content/uploads/2019/10/1571831320-6727-20170722232055731-2127042770.png" alt="img"></p>
<p>###由于我已经安装了MySQL 5.7.36，删除MySQL会连同数据库一起删除掉，所以现在看到的MySQL安装教程是我引用了另一个博主的博客。详情可以借鉴博客（原）：<a target="_blank" rel="noopener" href="https://www.cnblogs.com/xiaodingdong/p/7223245.html">https://www.cnblogs.com/xiaodingdong/p/7223245.html</a></p>
<p>[^]: </p>

      
    </div>
    <footer class="article-footer">
      <a data-url="http://example.com/2021/11/02/MySQL%E5%AE%89%E8%A3%85/" data-id="ckworu9ru00007ow38ueffhj4" data-title="MySQL安装" class="article-share-link">Share</a>
      
      
      
  <ul class="article-tag-list" itemprop="keywords"><li class="article-tag-list-item"><a class="article-tag-list-link" href="/tags/MySQL%E5%AE%89%E8%A3%85/" rel="tag">MySQL安装</a></li></ul>

    </footer>
  </div>
  
    
<nav id="article-nav">
  
  
    <a href="/2021/11/01/Tomcat%E5%AE%89%E8%A3%85/" id="article-nav-older" class="article-nav-link-wrap">
      <strong class="article-nav-caption">Older</strong>
      <div class="article-nav-title">tomcat</div>
    </a>
  
</nav>

  
</article>


</section>
        
          <aside id="sidebar">
  
    

  
    
  <div class="widget-wrap">
    <h3 class="widget-title">Tags</h3>
    <div class="widget">
      <ul class="tag-list" itemprop="keywords"><li class="tag-list-item"><a class="tag-list-link" href="/tags/MySQL%E5%AE%89%E8%A3%85/" rel="tag">MySQL安装</a></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/tomcat/" rel="tag">tomcat</a></li></ul>
    </div>
  </div>


  
    
  <div class="widget-wrap">
    <h3 class="widget-title">Tag Cloud</h3>
    <div class="widget tagcloud">
      <a href="/tags/MySQL%E5%AE%89%E8%A3%85/" style="font-size: 10px;">MySQL安装</a> <a href="/tags/tomcat/" style="font-size: 10px;">tomcat</a>
    </div>
  </div>

  
    
  <div class="widget-wrap">
    <h3 class="widget-title">Archives</h3>
    <div class="widget">
      <ul class="archive-list"><li class="archive-list-item"><a class="archive-list-link" href="/archives/2021/11/">November 2021</a></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2021/10/">October 2021</a></li></ul>
    </div>
  </div>


  
    
  <div class="widget-wrap">
    <h3 class="widget-title">Recent Posts</h3>
    <div class="widget">
      <ul>
        
          <li>
            <a href="/2021/11/02/MySQL%E5%AE%89%E8%A3%85/">MySQL安装</a>
          </li>
        
          <li>
            <a href="/2021/11/01/Tomcat%E5%AE%89%E8%A3%85/">tomcat</a>
          </li>
        
          <li>
            <a href="/2021/10/29/hello-world/">Hello World</a>
          </li>
        
      </ul>
    </div>
  </div>

  
</aside>
        
      </div>
      <footer id="footer">
  
  <div class="outer">
    <div id="footer-info" class="inner">
      
      &copy; 2021 John Doe<br>
      Powered by <a href="https://hexo.io/" target="_blank">Hexo</a>
    </div>
  </div>
</footer>

    </div>
    <nav id="mobile-nav">
  
    <a href="/" class="mobile-nav-link">Home</a>
  
    <a href="/archives" class="mobile-nav-link">Archives</a>
  
</nav>
    


<script src="/js/jquery-3.4.1.min.js"></script>



  
<script src="/fancybox/jquery.fancybox.min.js"></script>




<script src="/js/script.js"></script>





  </div>
</body>
</html>